/*
 Navicat Premium Dump SQL

 Source Server         : tencent
 Source Server Type    : MySQL
 Source Server Version : 80030 (8.0.30)
 Source Host           : 140.143.124.123:3306
 Source Schema         : chen

 Target Server Type    : MySQL
 Target Server Version : 80030 (8.0.30)
 File Encoding         : 65001

 Date: 12/04/2025 11:34:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
  `gid` int NOT NULL AUTO_INCREMENT,
  `gname` varchar(20) DEFAULT NULL,
  `gprice` decimal(20,2) DEFAULT NULL,
  `gweight` float DEFAULT NULL,
  `gdescript` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_goods
-- ----------------------------
BEGIN;
INSERT INTO `t_goods` (`gid`, `gname`, `gprice`, `gweight`, `gdescript`) VALUES (1, 'ccc', 2.10, 1, 'aa');
INSERT INTO `t_goods` (`gid`, `gname`, `gprice`, `gweight`, `gdescript`) VALUES (2, '遥遥领先牌手机', 9999.99, 1.1, 'good好用');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `uid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`uid`, `name`, `password`) VALUES (1, 'cgj', '666');
INSERT INTO `t_user` (`uid`, `name`, `password`) VALUES (2, 'zz', '888');
INSERT INTO `t_user` (`uid`, `name`, `password`) VALUES (3, 'gggg', '8888888');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
